﻿<%@ Page Title="" Language="C#" MasterPageFile="~/rightContent.Master" AutoEventWireup="true"
    CodeBehind="excel_docment.aspx.cs" Inherits="WEB.T_document.excel_docment" %>

<%@ Register Assembly="AjaxControlToolkit" Namespace="AjaxControlToolkit" TagPrefix="asp" %>
<asp:Content ID="Content1" ContentPlaceHolderID="head" runat="server">
    <style type="text/css">
        .style1
        {
            height: 31px;
        }
    </style>
</asp:Content>
<asp:Content ID="Content2" ContentPlaceHolderID="title" runat="server">
    导出签收表
</asp:Content>
<asp:Content ID="Content3" ContentPlaceHolderID="MainContent" runat="server">
    <script type="text/javascript" src="../js/My97DatePicker/WdatePicker.js"></script>
    <asp:ToolkitScriptManager ID="ToolkitScriptManager1" runat="server">
    </asp:ToolkitScriptManager>
    <table width="100%">
        <tr align="center">
            <td align="left" colspan="2">
                &nbsp;</td>
        </tr>
        <tr align="center">
            <td align="right">
                时间范围:</td>
            <td align="left" valign="top">
                <asp:TextBox ID="tbTimestart" runat="server" class="Wdate" Width="168px"></asp:TextBox>
                &nbsp;至 <asp:TextBox ID="tbTimestop" runat="server" class="Wdate" Width="168px"></asp:TextBox>
            </td>
        </tr>
        <tr align="center">
            <td align="right" class="style1">
                <asp:DropDownList ID="ddlQuery" runat="server">
                    <asp:ListItem Value="CustomerName">客户</asp:ListItem>
                </asp:DropDownList>
            </td>
            <td align="left" valign="top" class="style1">
                <asp:TextBox ID="tbQuery" runat="server" Width="166px"></asp:TextBox>
                <asp:AutoCompleteExtender ID="AutoCompleteExtender1" runat="server" ServiceMethod="GetCustomersName"
                              TargetControlID="tbQuery" MinimumPrefixLength="1" CompletionInterval="358">
                             </asp:AutoCompleteExtender>
                &nbsp;&nbsp;&nbsp;
                <asp:Button ID="btquery" runat="server" OnClick="btquery_Click" Text="  查 询" CssClass="Submit_Query" />
                &nbsp;&nbsp;
                <asp:Button ID="btExcel" runat="server" OnClick="btExcel_Click" Text="   导出签收表" 
                    CssClass="Submit_yellowDown" Height="27px" Width="104px" />
            </td>
        </tr>
        <tr align="center">
            <td align="right">
                单证模板:</td>
            <td align="left" valign="top">
                <asp:DropDownList ID="DropDownList1" runat="server" Height="23px" Width="172px">
                </asp:DropDownList>
                &nbsp;&nbsp;&nbsp;
                <asp:Button ID="Button1" runat="server" CssClass="Submit_yellowbig" OnClick="Button1_Click"
                    Text="查看单证模板" />
            </td>
        </tr>
        <tr align="center">
            <td colspan="2" valign="top">
                <asp:GridView ID="gvDocument" runat="server" AllowPaging="True" AutoGenerateColumns="False"
                    CellPadding="4" ForeColor="Black" GridLines="Vertical" OnPageIndexChanging="gvDocument_PageIndexChanging"
                    CssClass="distance" BackColor="White" BorderColor="#DEDFDE" BorderStyle="None"
                    BorderWidth="1px" PageSize="20" Width="1000px">
                    <AlternatingRowStyle BackColor="White" />
                    <Columns>
                        <asp:TemplateField>
                            <ItemTemplate>
                                <asp:CheckBox ID="cbDoc" runat="server" />
                            </ItemTemplate>
                        </asp:TemplateField>
                        <asp:BoundField DataField="sheetID" HeaderText="委托单号" />
                        <asp:BoundField DataField="客户名" HeaderText="客户名" />
                        <asp:BoundField DataField="编号" HeaderText="编号" />
                        <asp:BoundField DataField="日期" HeaderText="进出口日期" DataFormatString="{0:d}" />
                        <asp:BoundField DataField="船名" HeaderText="船名" />
                        <asp:BoundField DataField="提单数" HeaderText="提单数" />
                        <asp:BoundField DataField="货名" HeaderText="货名" />
                        <asp:BoundField DataField="提货单号" HeaderText="提货单号" />
                    </Columns>
                    <FooterStyle BackColor="#CCCC99" />
                    <HeaderStyle BackColor="#6B696B" Font-Bold="True" ForeColor="White" />
                    <PagerSettings LastPageText="末页" NextPageText="下一页" FirstPageText="首页" PreviousPageText="上一页" />
                    <PagerStyle BackColor="#F7F7DE" ForeColor="Black" HorizontalAlign="Right" />
                    <RowStyle BackColor="#F7F7DE" />
                    <SelectedRowStyle BackColor="#CE5D5A" Font-Bold="True" ForeColor="White" />
                    <SortedAscendingCellStyle BackColor="#FBFBF2" />
                    <SortedAscendingHeaderStyle BackColor="#848384" />
                    <SortedDescendingCellStyle BackColor="#EAEAD3" />
                    <SortedDescendingHeaderStyle BackColor="#575357" />
                </asp:GridView>
            </td>
        </tr>
        <tr align="center">
            <td colspan="2">
            </td>
        </tr>
    </table>
</asp:Content>
